Skip Headers

Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# RC_DATAFILE

This view lists information about all datafiles registered in the recovery catalog. It corresponds to the `V$DATAFILE` view. A datafile is shown as dropped if its tablespace was dropped.

Column | Datatype | Description
--- | --- | ---
`DB_KEY` | `NUMBER` | The primary key for this database in the recovery catalog. Use this column to form a join with almost any other catalog view.
`DBINC_KEY` | `NUMBER` | The primary key for the incarnation of the target database. Use this column to form a join with `RC_DATABASE_INCARNATION`.
`DB_NAME` | `VARCHAR2(8)` | The `DB_NAME` of the database incarnation to which this record belongs.
`TS#` | `NUMBER` | The number of the tablespace to which the datafile belongs. The `TS#` may exist multiple times in the same incarnation if the tablespace is dropped and re-created.
`TABLESPACE_NAME` | `VARCHAR2(30)` | The tablespace name. The name may exist multiple times in the same incarnation if the tablespace is dropped and re-created.
`FILE#` | `NUMBER` | The absolute file number of the datafile. The same datafile number may exist multiple times in the same incarnation if the datafile is dropped and re-created.
`CREATION_CHANGE#` | `NUMBER` | The SCN at datafile creation.
`CREATION_TIME` | `DATE` | The time of datafile creation.
`DROP_CHANGE#` | `NUMBER` | The SCN recorded when the datafile was dropped. If a new datafile with the same file number is discovered then the `DROP_CHANGE#` is set to `CREATION_CHANGE#` for the datafile; otherwise the value is set to `RC_CHECKPOINT`.`CKP_SCN`.
`DROP_TIME` | `DATE` | The time when the datafile was dropped. If a new datafile with the same file number is discovered then the `DROP_TIME` is set to `CREATION_TIME` for the datafile; otherwise the value is set to `RC_CHECKPOINT`.`CKP_TIME`.
`BYTES` | `NUMBER` | The size of the datafile in bytes.
`BLOCKS` | `NUMBER` | The size of the datafile in blocks.
`BLOCK_SIZE` | `NUMBER` | The size of the data blocks in bytes.
`NAME` | `VARCHAR2(1024)` | The datafile filename.
`STOP_CHANGE#` | `NUMBER` | For offline or read-only datafiles, the SCN value such that no changes in the redo stream at an equal or greater SCN apply to this file.
`STOP_TIME` | `DATE` | For offline normal or read-only datafiles, the time beyond which there are no changes in the redo stream that apply to this datafile.
`READ_ONLY` | `NUMBER` | 1 if the file is read-only; otherwise 0.
`RFILE#` | `NUMBER` | The relative file number of this datafile within its tablespace.
`INCLUDED_IN_DATABASE_BACKUP` | `VARCHAR2(3)` | Indicates whether this tablespace is included in whole database backups: `YES` or `NO`. The `NO` value occurs only if `CONFIGURE` `EXCLUDE` was run on the tablespace that owns this datafile.
`AUX_NAME` | `VARCHAR2(1024)` | Indicates the auxiliary name for the datafile as set by `CONFIGURE` `AUXNAME`.